| Purpose |
Need to Correct Coverage % LY YTD, Coverage % LY Total and LY Variance formulas and need to suppress Budget Total % when value is zero. |
| Release No |
004 |
| Submitted |
05-08-2013 |
| Submitted by |
Mallareddy D |
| Source/Destination Systems |
Remote Machine > Report > Enterprise Performance Mgmt Remote Machine > Report > Enterprise Performance Mgmt > North America Remote Machine > Report > Enterprise Performance Mgmt > Emerging Markets Remote Machine > Report > Enterprise Performance Mgmt > EMEA in BI 4.0 Dev Environment |
| Release Sent To |
Ashwin Shantikumar Kucheriya |
| Object(s) Created By |
Mallareddy D |
| Object(s) Tested By |
Uday Kumar P |
| SNo |
Field Name |
Formula |
Calculation |
Report Value |
Pass/Fail |
| 1 |
Coverage % for LY YTD |
Actual Revenue Shipped Current YTD/ Actual Revenue Shipped Last Year YTD * 100 |
372412/330945 * 100 = 112.5% |
112.5% |
P |
| 2 |
Coverage % for LY Total |
Total Revenue Current Year/ Total Revenue Last Year * 100 |
412419/949810 * 100 = 43.4% |
43.4% |
P |
| 3 |
LY YTD Variance |
Actual Revenue Shipped Current YTD - Actual Revenue Shipped Last Year YTD |
372412 - 330945 = 41466 |
41466 |
P |
| 4 |
Budget Total |
If value zero need to show blank value |
0 |
Blank |
P |